<?php
header('Content-Type: application/json');
require_once '_portal.php';

$sql = "SELECT `number`, `name`, `clientName`, `clientOffice`, `clientGroup` FROM `oprec_security_data` WHERE `disposed` = 0 ORDER BY CONVERT(name USING gbk) ASC";
$list = exec_sql($sql);
output($list);